USE [AESDB]
GO

/****** Object:  Table [dbo].[Jobs]    Script Date: 05/18/2013 13:10:44 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Jobs]') AND type in (N'U'))
DROP TABLE [dbo].[Jobs]
GO

USE [AESDB]
GO

/****** Object:  Table [dbo].[Jobs]    Script Date: 05/18/2013 13:10:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Jobs](
	[JobID] [int] IDENTITY(1,1) NOT NULL,
	[JobTitle] [nvarchar](max) NOT NULL,
	[JobLocation] [nvarchar](max) NOT NULL,
	[JobSalary] [nvarchar](max) NOT NULL,
	[JobDescription] [text] NOT NULL,
	[PositionsAvailable] [int] NOT NULL,
	[Active] [bit] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

